#—*—coding:utf-8 -*-
#@Time        :2022/7/18 16:17
#@Author      :dhx
#@File        :station_should_coll_tools.py
# @Software: PyCharm
import xlrd
import os
from config.config import DATAS_PATH
def read_data(file_name):
    """打开表格获取数据"""
    wb=xlrd.open_workbook(file_name)
    sheet=wb.sheet_by_index(0)
    print(sheet)

    lst=[]
    for i in range(1,sheet.nrows):
        lst.append(sheet.row_values(i))
    return lst

if __name__=='__main__':
    read_data(os.path.join(DATAS_PATH,'test_should_coll.xls'))

